<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-CN"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="Content-Language" content="zh-CN"><link href="stylesheet.css" media="all" rel="stylesheet" type="text/css">
<title>系统表</title>
<script> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?d286c55b63a3c54a1e43d10d4c203e75"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script>
</head><body class="CHAPTER">
<div>
<table summary="Header navigation table" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><th colspan="5" align="center" valign="bottom">PostgreSQL 8.2.3 中文文档</th></tr>
<tr><td width="10%" align="left" valign="top"><a href="executor.html" accesskey="P">后退</a></td><td width="10%" align="left" valign="top"><a href="overview.html">快退</a></td><td width="60%" align="center" valign="bottom"></td><td width="10%" align="right" valign="top"><a href="protocol.html">快进</a></td><td width="10%" align="right" valign="top"><a href="catalogs-overview.html" accesskey="N">前进</a></td></tr>
</table>
<hr align="LEFT" width="100%"></div>
<div class="CHAPTER"><h1><a name="CATALOGS"></a>章43. 系统表</h1>
<div>
<dl>
<dt><b>目录</b></dt>
<dt>43.1. <a href="catalogs-overview.html">概述</a></dt>
<dt>43.2. <a href="catalog-pg-aggregate.html"><tt class="STRUCTNAME">pg_aggregate</tt></a></dt>
<dt>43.3. <a href="catalog-pg-am.html"><tt class="STRUCTNAME">pg_am</tt></a></dt>
<dt>43.4. <a href="catalog-pg-amop.html"><tt class="STRUCTNAME">pg_amop</tt></a></dt>
<dt>43.5. <a href="catalog-pg-amproc.html"><tt class="STRUCTNAME">pg_amproc</tt></a></dt>
<dt>43.6. <a href="catalog-pg-attrdef.html"><tt class="STRUCTNAME">pg_attrdef</tt></a></dt>
<dt>43.7. <a href="catalog-pg-attribute.html"><tt class="STRUCTNAME">pg_attribute</tt></a></dt>
<dt>43.8. <a href="catalog-pg-authid.html"><tt class="STRUCTNAME">pg_authid</tt></a></dt>
<dt>43.9. <a href="catalog-pg-auth-members.html"><tt class="STRUCTNAME">pg_auth_members</tt></a></dt>
<dt>43.10. <a href="catalog-pg-autovacuum.html"><tt class="STRUCTNAME">pg_autovacuum</tt></a></dt>
<dt>43.11. <a href="catalog-pg-cast.html"><tt class="STRUCTNAME">pg_cast</tt></a></dt>
<dt>43.12. <a href="catalog-pg-class.html"><tt class="STRUCTNAME">pg_class</tt></a></dt>
<dt>43.13. <a href="catalog-pg-constraint.html"><tt class="STRUCTNAME">pg_constraint</tt></a></dt>
<dt>43.14. <a href="catalog-pg-conversion.html"><tt class="STRUCTNAME">pg_conversion</tt></a></dt>
<dt>43.15. <a href="catalog-pg-database.html"><tt class="STRUCTNAME">pg_database</tt></a></dt>
<dt>43.16. <a href="catalog-pg-depend.html"><tt class="STRUCTNAME">pg_depend</tt></a></dt>
<dt>43.17. <a href="catalog-pg-description.html"><tt class="STRUCTNAME">pg_description</tt></a></dt>
<dt>43.18. <a href="catalog-pg-index.html"><tt class="STRUCTNAME">pg_index</tt></a></dt>
<dt>43.19. <a href="catalog-pg-inherits.html"><tt class="STRUCTNAME">pg_inherits</tt></a></dt>
<dt>43.20. <a href="catalog-pg-language.html"><tt class="STRUCTNAME">pg_language</tt></a></dt>
<dt>43.21. <a href="catalog-pg-largeobject.html"><tt class="STRUCTNAME">pg_largeobject</tt></a></dt>
<dt>43.22. <a href="catalog-pg-listener.html"><tt class="STRUCTNAME">pg_listener</tt></a></dt>
<dt>43.23. <a href="catalog-pg-namespace.html"><tt class="STRUCTNAME">pg_namespace</tt></a></dt>
<dt>43.24. <a href="catalog-pg-opclass.html"><tt class="STRUCTNAME">pg_opclass</tt></a></dt>
<dt>43.25. <a href="catalog-pg-operator.html"><tt class="STRUCTNAME">pg_operator</tt></a></dt>
<dt>43.26. <a href="catalog-pg-pltemplate.html"><tt class="STRUCTNAME">pg_pltemplate</tt></a></dt>
<dt>43.27. <a href="catalog-pg-proc.html"><tt class="STRUCTNAME">pg_proc</tt></a></dt>
<dt>43.28. <a href="catalog-pg-rewrite.html"><tt class="STRUCTNAME">pg_rewrite</tt></a></dt>
<dt>43.29. <a href="catalog-pg-shdepend.html"><tt class="STRUCTNAME">pg_shdepend</tt></a></dt>
<dt>43.30. <a href="catalog-pg-shdescription.html"><tt class="STRUCTNAME">pg_shdescription</tt></a></dt>
<dt>43.31. <a href="catalog-pg-statistic.html"><tt class="STRUCTNAME">pg_statistic</tt></a></dt>
<dt>43.32. <a href="catalog-pg-tablespace.html"><tt class="STRUCTNAME">pg_tablespace</tt></a></dt>
<dt>43.33. <a href="catalog-pg-trigger.html"><tt class="STRUCTNAME">pg_trigger</tt></a></dt>
<dt>43.34. <a href="catalog-pg-type.html"><tt class="STRUCTNAME">pg_type</tt></a></dt>
<dt>43.35. <a href="views-overview.html">系统视图</a></dt>
<dt>43.36. <a href="view-pg-cursors.html"><tt class="STRUCTNAME">pg_cursors</tt></a></dt>
<dt>43.37. <a href="view-pg-group.html"><tt class="STRUCTNAME">pg_group</tt></a></dt>
<dt>43.38. <a href="view-pg-indexes.html"><tt class="STRUCTNAME">pg_indexes</tt></a></dt>
<dt>43.39. <a href="view-pg-locks.html"><tt class="STRUCTNAME">pg_locks</tt></a></dt>
<dt>43.40. <a href="view-pg-prepared-statements.html"><tt class="STRUCTNAME">pg_prepared_statements</tt></a></dt>
<dt>43.41. <a href="view-pg-prepared-xacts.html"><tt class="STRUCTNAME">pg_prepared_xacts</tt></a></dt>
<dt>43.42. <a href="view-pg-roles.html"><tt class="STRUCTNAME">pg_roles</tt></a></dt>
<dt>43.43. <a href="view-pg-rules.html"><tt class="STRUCTNAME">pg_rules</tt></a></dt>
<dt>43.44. <a href="view-pg-settings.html"><tt class="STRUCTNAME">pg_settings</tt></a></dt>
<dt>43.45. <a href="view-pg-shadow.html"><tt class="STRUCTNAME">pg_shadow</tt></a></dt>
<dt>43.46. <a href="view-pg-stats.html"><tt class="STRUCTNAME">pg_stats</tt></a></dt>
<dt>43.47. <a href="view-pg-tables.html"><tt class="STRUCTNAME">pg_tables</tt></a></dt>
<dt>43.48. <a href="view-pg-timezone-abbrevs.html"><tt class="STRUCTNAME">pg_timezone_abbrevs</tt></a></dt>
<dt>43.49. <a href="view-pg-timezone-names.html"><tt class="STRUCTNAME">pg_timezone_names</tt></a></dt>
<dt>43.50. <a href="view-pg-user.html"><tt class="STRUCTNAME">pg_user</tt></a></dt>
<dt>43.51. <a href="view-pg-views.html"><tt class="STRUCTNAME">pg_views</tt></a></dt>
</dl>
</div>
<p>系统表是关系型数据库存放结构元数据的地方，比如表和字段以及内部登记信息等。PostgreSQL 的系统表就是普通表。你可以删除然后重建这些表、增加列、插入和更新数值，然后彻底把系统搞垮。不应该手工修改系统表，通常总有 SQL 命令可以做这些事情。比如，<tt class="COMMAND">CREATE DATABASE</tt> 向 <tt class="STRUCTNAME">pg_database</tt> 表插入一行，并且实际上在磁盘上创建该数据库。有几种特别深奥的操作例外，比如增加索引访问方法。</p>
</div>
<div>
<hr align="LEFT" width="100%">
<table summary="Footer navigation table" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="33%" align="left" valign="top"><a href="executor.html" accesskey="P">后退</a></td><td width="34%" align="center" valign="top"><a href="index.html" accesskey="H">首页</a></td><td width="33%" align="right" valign="top"><a href="catalogs-overview.html" accesskey="N">前进</a></td></tr>
<tr><td width="33%" align="left" valign="top">执行器</td><td width="34%" align="center" valign="top"><a href="internals.html" accesskey="U">上一级</a></td><td width="33%" align="right" valign="top">概述</td></tr>
</table>
</div>
</body></html>